import xlrd


def Addition(st, data_list):
    row_num = st.nrows

    for i in range(1, row_num):
        data_list.append(st.row_values(i))


class EditCardData:
    book = xlrd.open_workbook(filename='D:/工作/2023年6月/test_data.xlsx')

    st = book.sheet_by_name('editcard_name_data')

    editcard_name_data = []

    Addition(st, editcard_name_data)

    st = book.sheet_by_name('editcard_num_data')

    editcard_num_data = []

    Addition(st, editcard_num_data)

    st = book.sheet_by_name('editcard_illegalnum_data')

    editcard_illegalnum_data = []

    Addition(st, editcard_illegalnum_data)

    st = book.sheet_by_name('editcard_type_data')

    editcard_type_data = []

    Addition(st, editcard_type_data)
